@ECHO OFF
set /p SQLSERVER= Give the SQL Server instance name?
set /p USERNAME= Give the user name?
set /p PWD= Give the password?

CD .\TableCreationScripts
SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d IvyDB -i Ivy_CallAllTableCreationScripts.SQLCMD
CD ..\

CD .\StoredProcedureScripts
SQLCMD -S %SQLSERVER% -U %USERNAME% -P %PWD% -d IvyDB -i Ivy_CallAllStoredProcScripts.SQLCMD
CD ..\

PAUSE
@ECHO ON